UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6XhJXhdSnt7lc44pcpdmiVSv7gzjTaK2hnKxUPWoCL8='
WHERE
key_id = 'fd9d4b67afa8a806d1ca391a0202c3ad25d16b84641a4b6a90a16944f314b212'
AND (
token = '6XhJXhdSnt7lc44pcpdmiVSv7gzjTaK2hnKxUPWoCL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)