UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HNw9m80PkK8Ca4XS25Mn/JhaqHPZrEXOzxwCjhwv758=' 
WHERE 
  key_id = '019a02f847ec5d745bce9be68a518fd0daba29fd5e47a16583ad136eb24f6b93' 
  AND (
    token = 'HNw9m80PkK8Ca4XS25Mn/JhaqHPZrEXOzxwCjhwv758=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033