UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1nS1yqCY/s4iLPlXXbImKmtvfeC03xkUzVCHgOZm0K4='
WHERE
key_id = '484a8530a053b029debe5beac58cc34045951c550da41c112862a6ab82eaf00a'
AND (
token = '1nS1yqCY/s4iLPlXXbImKmtvfeC03xkUzVCHgOZm0K4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)