UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZQcE4r0YDCiAzFwJA06miPB1X5jNBNkYur+E3R7VAOw='
WHERE
key_id = 'c87863bbf25a2e517c09c79942014a7fb654bd21ec1c98f8b022fd6e2eab97a5'
AND (
token = 'ZQcE4r0YDCiAzFwJA06miPB1X5jNBNkYur+E3R7VAOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)