UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6XMVP30tt2vIHTRIJn3/QsibK44wsv7CifPD8XCcV08='
WHERE
key_id = '519ea715c02925899ce644f7a2304bf0ecfa48348046794364d26f23802a1b40'
AND (
token = '6XMVP30tt2vIHTRIJn3/QsibK44wsv7CifPD8XCcV08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)