UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6v5ExdbqZPgtED2L3Vojsqsw16VdWUkT5Z1gdR+4uso='
WHERE
key_id = 'd249126ddfeae5c6f4ab1cb4377d31b4c8669425c9ef52ccdba8ad858963f5d3'
AND (
token = '6v5ExdbqZPgtED2L3Vojsqsw16VdWUkT5Z1gdR+4uso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)