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