UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KwdP4cLhY8jTFQSeOLONZFmgHCNcWTuhUpX7jYbp+U8='
WHERE
key_id = '95342b7c9e3067319418d42e0fe4575fa7827fce4e859bc7b47051f57d775f3a'
AND (
token = 'KwdP4cLhY8jTFQSeOLONZFmgHCNcWTuhUpX7jYbp+U8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)