UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'm4xAfAp46GZ71Z7LXNsPH/PLtHdjMdstU9Y+Nqv70KI=' 
WHERE 
  key_id = '3ad3d83d50c9a3163037f75dd749a6ce3d60154863712d53f8d36058ad62428c' 
  AND (
    token = 'm4xAfAp46GZ71Z7LXNsPH/PLtHdjMdstU9Y+Nqv70KI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026