UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'I3T6q+Gnb5ciodcPD9HUKexKj5rfVYuECCxHG5cSShU=' 
WHERE 
  key_id = '55de012fcb6791c0a35f8eeb9015fd0a2f18f592cb913d3a3d8bf87aab32a5ba' 
  AND (
    token = 'I3T6q+Gnb5ciodcPD9HUKexKj5rfVYuECCxHG5cSShU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026