UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2u7f+c5fHy4jMJn5K8lo/PDXCF9w91LylHJ5KK6tKUA='
WHERE
key_id = '02efe7adac46a7343060237bc650106a66f323f0d85d5756f5df4ae865473d0d'
AND (
token = '2u7f+c5fHy4jMJn5K8lo/PDXCF9w91LylHJ5KK6tKUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)