UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zfLlDwChXqhWZeeW23w21Hs+N9auqsEKlAnHHEJ7mUo='
WHERE
key_id = 'b542100cdccb6ad610f420ac8645c2e8445378847609e2008b5f24ae2b970bed'
AND (
token = 'zfLlDwChXqhWZeeW23w21Hs+N9auqsEKlAnHHEJ7mUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)