UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CjHAppUzYo9EcM0rC91MBJ0zVp41EJ59jW7q5StNztQ=' 
WHERE 
  key_id = 'ab9067ea8c7ff2361787df0017b7248c67f2c35ae8388cbe66b0c73e84f825c5' 
  AND (
    token = 'CjHAppUzYo9EcM0rC91MBJ0zVp41EJ59jW7q5StNztQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029