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