UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D2A31hRONioz7Pu276LRiAmfeqIvOz2qdtAZacgKp0E='
WHERE
key_id = '6670a1c6aec60af568d32eef2980a5dd91172e52f2f48470749303f23a3c8203'
AND (
token = 'D2A31hRONioz7Pu276LRiAmfeqIvOz2qdtAZacgKp0E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)