UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4F+lhQIK/xfrIYjc4QrQnt9PRpheVxwpZaCJDWg5ums=' 
WHERE 
  key_id = '6c5d7c28c5525d94a3f0181d0c2f488ed530dd8f8bb31f3cedefbc0529aa13cc' 
  AND (
    token = '4F+lhQIK/xfrIYjc4QrQnt9PRpheVxwpZaCJDWg5ums=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023