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