UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Pl4jRZCJX5V7JklYsz1sGO2LLJn7qAplV6u96k+lDo='
WHERE
key_id = '5eb6eff22822ae5ae0d0ff707359c67a01a6afbc58523aa6cb10824d49075b8b'
AND (
token = '1Pl4jRZCJX5V7JklYsz1sGO2LLJn7qAplV6u96k+lDo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)