UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Ah7Z3B6N3g9UyKHt6s4AmtzYKFlbaxGxIYKILSBWiw='
WHERE
key_id = 'f97e366a95ed9ca04e54bd497a55da7a6ec8ece1b83fdb7967dfbddc6291975f'
AND (
token = '7Ah7Z3B6N3g9UyKHt6s4AmtzYKFlbaxGxIYKILSBWiw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)