UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bZSaZvb3ympV1oMQ5upo9KvoEAD5gLn3K8JNGi4phfc='
WHERE
key_id = '26f80cfc6dd474968185bcaaf74a17a69c3a43c9018b651bd0bcab08b61dc11e'
AND (
token = 'bZSaZvb3ympV1oMQ5upo9KvoEAD5gLn3K8JNGi4phfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)