UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hZrWoMayNRvVkgRO52Ekq3Onwe8t0c0tC8gEUGgZVWM='
WHERE
key_id = '9f8f253a393e9f6c1a85c871a7e86696c23b25c4362411b1bf7dd8ad92b35229'
AND (
token = 'hZrWoMayNRvVkgRO52Ekq3Onwe8t0c0tC8gEUGgZVWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)