UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9BrH4Z1Ig2RF9uVYQiRP5ABq9nyxMrzYAMziL62+3Rc='
WHERE
key_id = '514561d4cc5b12e940b0916a2a64b8ffeef625dda641512bfcf31f6e9a86a7dc'
AND (
token = '9BrH4Z1Ig2RF9uVYQiRP5ABq9nyxMrzYAMziL62+3Rc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)