UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'yxCaIFpirPna9yNtYrXmjl3c00Tqu5sXtzPiIGx3yD0=' 
WHERE 
  key_id = '4a51a300d25a32f271efe919c359bcb661e8d3fcbf6b9b557623d5e29a2c6af0' 
  AND (
    token = 'yxCaIFpirPna9yNtYrXmjl3c00Tqu5sXtzPiIGx3yD0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026