UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R2S4b+C2yaHXMtmiOs1FSW7f81JX+YWK6I2qumCaceU='
WHERE
key_id = '7d70d22a13bc8967b592bfab501d8f0040455eab15a4f500618501014a7311a3'
AND (
token = 'R2S4b+C2yaHXMtmiOs1FSW7f81JX+YWK6I2qumCaceU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)