UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pOo/Lr35+gIH5bzNuQwa0glryZfEhijQiI+RRpC7Xeo=' 
WHERE 
  key_id = '8b187f26348e3b9d5e0dd83eafbbfa2054b86affe84a7f7e42599d0c57642b57' 
  AND (
    token = 'pOo/Lr35+gIH5bzNuQwa0glryZfEhijQiI+RRpC7Xeo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022