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