UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'SE+u6p3GPzSIXo8KRLpKnvTax3l4G0Y6VN2hRgOnUYQ=' 
WHERE 
  key_id = '3e0b6afa8f1c73705d1bb5e108f7150fafea8e4556d617cda325e10ab66f808b' 
  AND (
    token = 'SE+u6p3GPzSIXo8KRLpKnvTax3l4G0Y6VN2hRgOnUYQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032