UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'kEixtdBbFz8M/moJrnXSf3Q7kKBQa4v9L97kDgsdzSA=' 
WHERE 
  key_id = 'aefceb8980cc5f288ba2851da9620a427cfa437cc169fd22f67444436c88ea6e' 
  AND (
    token = 'kEixtdBbFz8M/moJrnXSf3Q7kKBQa4v9L97kDgsdzSA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028