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