UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c4tstUNi+wb+W4cA8WoKhSF+iZnegLVnfIbPbGufXc8='
WHERE
key_id = '2872679c92e0d6e1e09262eed61f70ece9144f26ee1fab56202ea4fe8854c481'
AND (
token = 'c4tstUNi+wb+W4cA8WoKhSF+iZnegLVnfIbPbGufXc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)