UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PFNESHB0Jq5ZiAJ7DrP0SAeYcom+Bjwvrd9MHrk9CH0='
WHERE
key_id = 'cd10c3635605384cf247b2d71d4c67132ab9d74b9eb76d5e6978324d97b21523'
AND (
token = 'PFNESHB0Jq5ZiAJ7DrP0SAeYcom+Bjwvrd9MHrk9CH0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)