UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xCaZghMJJYrmhFy25RobnC0SvktSuf4b7KIx+Noaaz8='
WHERE
key_id = 'e97c0dce5399ee66c94db421b976a75d3d23c6d1da9b8bb6adc5bd29c12765dc'
AND (
token = 'xCaZghMJJYrmhFy25RobnC0SvktSuf4b7KIx+Noaaz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)