UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CtiucR41inI9qM4r5vh2C9Z3L6yjFvN2mjODNWkvQMw='
WHERE
key_id = 'ae446e1cf025ef62e3a229d874f22a74f15a062834d26e326a23cfb5614d22bf'
AND (
token = 'CtiucR41inI9qM4r5vh2C9Z3L6yjFvN2mjODNWkvQMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)