UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MIQiFSN14/A3EY8lfVGpWTBW//pOQCeKNlTYQGUg6Iw='
WHERE
key_id = 'c10f709c59748969786e80fd11cfaca7c3c970ef627c36baf20ce087d16e98da'
AND (
token = 'MIQiFSN14/A3EY8lfVGpWTBW//pOQCeKNlTYQGUg6Iw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)