UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a0ObZ02sE9Yp3YA1EluO50a+EfLcPDikTDKgI7NCKjg='
WHERE
key_id = 'c8b5220659fa4735d12c456543d49a51842e8881fc910cabadef3529e4aa1003'
AND (
token = 'a0ObZ02sE9Yp3YA1EluO50a+EfLcPDikTDKgI7NCKjg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)