UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hSFUjiYE4N+TW35GoHlFVygz3fsVDAHt2E/DhE2AWvg=' 
WHERE 
  key_id = '84fa22447c4a157cba5a00bc21fe4d5fe7854de58c4621ed1a595a69b4d8c7b4' 
  AND (
    token = 'hSFUjiYE4N+TW35GoHlFVygz3fsVDAHt2E/DhE2AWvg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029