UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jw2cV8NZXQbNVmvAdh7/fBfv3tSBNK0avG9wFRKiKL4='
WHERE
key_id = 'c871657ed0ac80d89268bc42fe074dc3a9b112ae3afe37bfd6b7e74681588686'
AND (
token = 'Jw2cV8NZXQbNVmvAdh7/fBfv3tSBNK0avG9wFRKiKL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)