UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZIEv+/evdXRiB8JyBz4HzDjoG8xbrryZS63OqFwcCkM=' 
WHERE 
  key_id = 'a159ecd0ebab0241af1580cc228ed3a7a87de25eb73836aeb6dd670df94351af' 
  AND (
    token = 'ZIEv+/evdXRiB8JyBz4HzDjoG8xbrryZS63OqFwcCkM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046