UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'weOW9ZbWq38nK2hpQ867xsNghXgfJVoEM7ZgTS0Oo0U='
WHERE
key_id = '54254359f8cb4e58ad880c68e349442624922c37ca39e178f881de13a86ce91d'
AND (
token = 'weOW9ZbWq38nK2hpQ867xsNghXgfJVoEM7ZgTS0Oo0U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)