UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qZOlpJEK+IjloKitYKGItTzh0dqEwyC5OfdPthLrwxY='
WHERE
key_id = 'bd316b9a5a0c4c0b319ffb101eee65e609936f0875791ee25e6f2f96717664ed'
AND (
token = 'qZOlpJEK+IjloKitYKGItTzh0dqEwyC5OfdPthLrwxY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)