UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YfkkyxSO7vh++91zyjI/WtOvSD/fmYq997UgjokDuPs='
WHERE
key_id = '78098cd7d46d1524d150551b541e9749ab19989c1fc38569bae67b842204876e'
AND (
token = 'YfkkyxSO7vh++91zyjI/WtOvSD/fmYq997UgjokDuPs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)