UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U54ncJpgtsijAmna5qhZ01W1Iyk+JE/wQQ97BMHh9TI='
WHERE
key_id = '1e9ca58c542fb7b75f386518fd7a5862e4e32c32e7e93802a7bdfacff206445a'
AND (
token = 'U54ncJpgtsijAmna5qhZ01W1Iyk+JE/wQQ97BMHh9TI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)