UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n1CckSyJMqciE6ZtdBwkg8ujQE9dgdQscJvUpKiLcUI='
WHERE
key_id = '28ed20f66362b3bb7e58d8db288a3c9ae9b711a51c6c909c6a220502797c9ebb'
AND (
token = 'n1CckSyJMqciE6ZtdBwkg8ujQE9dgdQscJvUpKiLcUI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)