UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BCXnEEurbdrc5VGx4Pq1rV8s/FkDdGjToa2ZfJIztVQ='
WHERE
key_id = 'ca71ee114fdd9a443f2c5acde98fe7206c0d39805108bccdb8259e0cfb8ed20e'
AND (
token = 'BCXnEEurbdrc5VGx4Pq1rV8s/FkDdGjToa2ZfJIztVQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)