UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZP05Nuaf4tngZ5akoJnOQzJIbJWalkJ8FM2jkcQZKws='
WHERE
key_id = '9e3256ffa787f0d4b9a7a94a83972aaa5d37d2e017b2ba82926f17db881a71df'
AND (
token = 'ZP05Nuaf4tngZ5akoJnOQzJIbJWalkJ8FM2jkcQZKws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)