UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'H+kAH75j/uYJDK3U7vDMesmqWx8AJWjexpe7csqPaic=' 
WHERE 
  key_id = 'c2e9430b4b9c03d9566b84e3556e0d9c196de3ba14feff88f1334224ae4600f6' 
  AND (
    token = 'H+kAH75j/uYJDK3U7vDMesmqWx8AJWjexpe7csqPaic=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022